Param(
[string]$server='FIBICH-ACER\SQLEXPRESS',
[string]$db='CensusData',
[string]$userName="",
[string]$password="",
[string]$schema='ACSSF',
[string]$table='Summary_File_0001',
[string]$inputFile="ACSSF\e20131va0001000.txt",
[string]$formatFile="ACSSF_Summary_File_0001.fmt"
)

gci ACSSF -filter e20121*0001000.txt | % {
	$_.name; 
	$x=$_.FullName;
	$x;
	.\BCP-in.ps1 $server $db $userName $password 'ACSSF' 'Summary_File_0001' """$x""" "ACSSF_Summary_File_0001.fmt"
};
